IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'EDUCATION_GROUP')
BEGIN
    DROP TABLE [dbo].[EDUCATION_GROUP]
END

GO

CREATE TABLE [dbo].[EDUCATION_GROUP] ( 
	[ID]			INT IDENTITY(1,1)   NOT FOR REPLICATION     NOT NULL,
    [SHORT_NAME]    VARCHAR(20)         NOT NULL	UNIQUE,
    [DESCRIPTION]   VARCHAR(256)

    CONSTRAINT [PK_EDUCATION_GROUP_ID] PRIMARY KEY CLUSTERED ( 
        [ID] 
    ) ON [PRIMARY]
    
) ON [PRIMARY] 

CREATE INDEX [IDX_EDUCATION_GROUP_SHORT_NAME] on [dbo].[EDUCATION_GROUP] ([SHORT_NAME])

GO